package com.lantosec.hmrp.modules.category.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lantosec.hmrp.modules.category.entity.AssetsCount;
import com.lantosec.hmrp.modules.category.entity.AssetsInfo;
import com.lantosec.hmrp.modules.category.entity.Statistical;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
 * <p>
 * 资产信息表 Mapper 接口
 * </p>
 *
 * @author AutoCode
 * @since 2020-03-31
 */
public interface AssetsInfoMapper extends BaseMapper<AssetsInfo> {

    void realDelete(String it);

    void audit(String it);

    String selectMaxAssetsCode();

    void saveImage(@Param("photoList") String photoList, @Param("assetsId") String assetsId,@Param("date") Date date);

    String selectMaxDirId();

    void updateCategoryId(@Param("dirId") String dirId, @Param("categoryId") String categoryId);

    void updateDirId(@Param("assetsId") String it, @Param("dirId") String dirId);

    AssetsCount getCountForLableType(@Param("deptId") String deptId, @Param("areaId") String areaId,@Param("categoryList") String categoryList);

    AssetsCount getCheckCount(@Param("planId") String planId ,@Param("deptId") String deptId, @Param("areaId") String areaId,@Param("categoryList")String categoryList);

    List<AssetsInfo> getAssetsLableList(@Param("deptId")String deptId, @Param("areaId")String areaId,@Param("categoryList")String categoryList);

    List<AssetsInfo> getCountByRfid(@Param("deptId")String deptId, @Param("areaId")String areaId,@Param("categoryList")String categoryList);

    List<Statistical> statisticalByUserDept();

    List<Statistical> statisticalBycategoryId();

    List<Statistical> statisticalByLableType();

    List<Statistical> statisticalByState();

    List<Statistical> statisticalByPrice();
}
